UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tIOlEUu18NvSNGJu2bdm9ANdO8yjg6YHA+989JWSMdo='
WHERE
key_id = '6586cbd7ef4819b9ac7aa89b483eb565597b8abed230026697a203ea27bf55c1'
AND (
token = 'tIOlEUu18NvSNGJu2bdm9ANdO8yjg6YHA+989JWSMdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)