UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zzcdyiZNASootoadLKRV4sJsE6BN4A7Ksf7lkJn3UMk='
WHERE
key_id = '27b56e0d66d6581992816fbb97ca5c50166a967fdf3c787d97e8eb09fc9acd63'
AND (
token = 'zzcdyiZNASootoadLKRV4sJsE6BN4A7Ksf7lkJn3UMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)