UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7QBKcNrkzE8gyTQIyeH9Vh+OoeKZUWT7nZ/bG2EqZP8='
WHERE
key_id = '1918d548977178124c203c1203f42944d89d5be6d387857b813abb3ebe55f491'
AND (
token = '7QBKcNrkzE8gyTQIyeH9Vh+OoeKZUWT7nZ/bG2EqZP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)