UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9UQF2rqufXuymRBoGpD4445zwRfm2BIbJ5eCx0d7Euo='
WHERE
key_id = '837c87ca9393a3e2cffe690662ae0af785a090a0eb4e5a09e434a3172128f5c7'
AND (
token = '9UQF2rqufXuymRBoGpD4445zwRfm2BIbJ5eCx0d7Euo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)