UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pPd2mf5MGArBlDezq7lu1agNCUQ6qR9ER7/PDnL3HQ='
WHERE
key_id = 'de917557bed6d248743b60c074d6510bb9e304bd381ba6a8cf12d10f4ab3ef6a'
AND (
token = '8pPd2mf5MGArBlDezq7lu1agNCUQ6qR9ER7/PDnL3HQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)