UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQZ2ai6qUf8I5jnVJn451kidpyJrJ2gazc8VMQfclbE='
WHERE
key_id = '554a4692cd237874f96ad7dd4f2c082f28c0f774ca10b87d470c288eabf10ee1'
AND (
token = 'nQZ2ai6qUf8I5jnVJn451kidpyJrJ2gazc8VMQfclbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)