UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HqaPkcIxNGLMhZi7OeMx0NENcPortbwSHIwtKAtZXgo='
WHERE
key_id = 'df3bc21afc2a39a84fa1de2b1484ee2dbb39f3e38fa1baa3ffbb3bf47c3a6bbd'
AND (
token = 'HqaPkcIxNGLMhZi7OeMx0NENcPortbwSHIwtKAtZXgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)