UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M+vj6TPQpdsHCNABiAbf89l12EDqu3CqbU+gvzXZIu8='
WHERE
key_id = 'c0049c3c14b6a948d090bfdbc7a61830943580c2cc3a39fa39728b19da7cf7dc'
AND (
token = 'M+vj6TPQpdsHCNABiAbf89l12EDqu3CqbU+gvzXZIu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)