UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q6rYcnlphGXQHwMrDBoE012rZUyNsE3v/iT2O5agIcA='
WHERE
key_id = '0a59e186604a1ee9a126462a04b14a2b60e316545147e273e884dec4369189b0'
AND (
token = 'Q6rYcnlphGXQHwMrDBoE012rZUyNsE3v/iT2O5agIcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)