UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UpT8UeQ65TUH1NWQ7+mpB2K/LwdrQVHmc25sAgHIcKE='
WHERE
key_id = '52d6fd03a2d462962d137a004d6ac130fee542a73b4ccb05ea25b6489dac5f28'
AND (
token = 'UpT8UeQ65TUH1NWQ7+mpB2K/LwdrQVHmc25sAgHIcKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)