UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZiXv16sB3B/LCwYicjDpCHIHjcmUxGmGdiN1mKLHVY='
WHERE
key_id = '117d2515bdafd20c0021d84e00aad5b1cf2dc2e1baa312238f2b8a4e3ca8f42c'
AND (
token = 'pZiXv16sB3B/LCwYicjDpCHIHjcmUxGmGdiN1mKLHVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)