UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oA5SShYhKCMk1Jw/Zssj64+7+We2JqGPyo3lScfktcE='
WHERE
key_id = '6d89f96de60235cd85e2316c47dea0e74b094fab2d213e3cbcb0fede8c7d84de'
AND (
token = 'oA5SShYhKCMk1Jw/Zssj64+7+We2JqGPyo3lScfktcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)