UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Jnn8dMgNrgUkvtB1TndPujpxeWg+bOwwrexD+HFc0E='
WHERE
key_id = '74197a3a1508fda7e883389a04529c7ad25668b3512e3fe578f751103ca4df28'
AND (
token = '0Jnn8dMgNrgUkvtB1TndPujpxeWg+bOwwrexD+HFc0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)