UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4N1wCgccRUjjk0zg4hkFXj7ME83wLh6uJPe1ufGmc58='
WHERE
key_id = 'c229d102a5f0a859718d9e7368a57f7d1fad6a2e0c70e59c24c383ea7978e3a1'
AND (
token = '4N1wCgccRUjjk0zg4hkFXj7ME83wLh6uJPe1ufGmc58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)