UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9TjG/caqz6Yg6py6G1YFZgmSG95qJm/w8UXSlvZ+RSk='
WHERE
key_id = '719e9668b691345f39c645d62bc06ba0386eb7abf85e0c0ae2e0e141184a26dc'
AND (
token = '9TjG/caqz6Yg6py6G1YFZgmSG95qJm/w8UXSlvZ+RSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)