UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YgFRxvtxuvlDMTfMjZBCHvCpFiKUqRwovYkIhr9w+34='
WHERE
key_id = 'ec3de8a372a901e375b7e3072eb4de9f688c13f23dd665e2cb683a06465dc234'
AND (
token = 'YgFRxvtxuvlDMTfMjZBCHvCpFiKUqRwovYkIhr9w+34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)