UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9wnDqE4T7vXiXt5pMqbplbDZnp8GjFI67vwFKbKOXOw='
WHERE
key_id = 'f94848841b9476e80b0fb7ae394471bfbe48d3176902273eb8c1d5129f0e21ff'
AND (
token = '9wnDqE4T7vXiXt5pMqbplbDZnp8GjFI67vwFKbKOXOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)