UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'czEJwb6AzRrRaa7jOanMm9tfE7iuJCrJLjWWySfa1V8='
WHERE
key_id = '94d38b0121762a1819ade57834ea03c3813fb07ac9ff4e149795863972ddd080'
AND (
token = 'czEJwb6AzRrRaa7jOanMm9tfE7iuJCrJLjWWySfa1V8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)