UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T9rh9X4P7YK83uVuZ30Tb/HRDcZHaB/jrpo3cfWCzTU='
WHERE
key_id = 'b196f53640dbdb5d11e60845dd00f1df8063570180ad069445b4b2230962cd37'
AND (
token = 'T9rh9X4P7YK83uVuZ30Tb/HRDcZHaB/jrpo3cfWCzTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)