UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BICm83jENksl4MVdNxUPI2jFCR+aAsGoMBcl7Ec1cm8='
WHERE
key_id = '7c2ac08333c5f0117ec7cb41ff72c965bdc1859908a522195563bf2eef1eccea'
AND (
token = 'BICm83jENksl4MVdNxUPI2jFCR+aAsGoMBcl7Ec1cm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)