UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W+lAEbtP0YHEmc3lLtgybzUzRnDKSE6y0nKbBMGNWqw='
WHERE
key_id = 'f9ae94933ad86b2abfa5072a946d77e8c8b0c875ce8a4f721991bf0ac9ddf7a4'
AND (
token = 'W+lAEbtP0YHEmc3lLtgybzUzRnDKSE6y0nKbBMGNWqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)