UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IiGyTvLiAwxDSA8HDJO3MM67LviPVFn7uQzBlqVWBPw='
WHERE
key_id = '87bcadf36a4d188c113073de5de015d23d77ccfa6847d9330a1d9c551fd44aaf'
AND (
token = 'IiGyTvLiAwxDSA8HDJO3MM67LviPVFn7uQzBlqVWBPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)