UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DgIMV0qi5y7eUwx9tv+GU3TiZtjf5A5apP/FaU80fds='
WHERE
key_id = '1e78256c07f3c610876988a1749b60c82fb2006f59d9a554c264440adc65f626'
AND (
token = 'DgIMV0qi5y7eUwx9tv+GU3TiZtjf5A5apP/FaU80fds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)