UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sGzvtafj9Vceflm/umRsd511Kes0+qxnE2pLAesNA7Y='
WHERE
key_id = '4dae1ae3fe69a2532aea70ff58c3d50e6d2006d7998d4fa688f0a99f378c854f'
AND (
token = 'sGzvtafj9Vceflm/umRsd511Kes0+qxnE2pLAesNA7Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)