UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DLJIEeSMCi18YNvsg0eFtZXQCA8a3DZrHGUgF9nV8Ks='
WHERE
key_id = 'c6bb24d4275294139562bd4f247fa81a44b6f38a0f27e38afff036bcc244f970'
AND (
token = 'DLJIEeSMCi18YNvsg0eFtZXQCA8a3DZrHGUgF9nV8Ks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)