UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q6odEWKFGuKoMZkr2gBc/WHIGP6tTOAjDHC6HTh2cJE='
WHERE
key_id = 'f3b83328962d225dc86a2789e6188ec6efc628ddaf2317bd550d04f6c0877116'
AND (
token = 'q6odEWKFGuKoMZkr2gBc/WHIGP6tTOAjDHC6HTh2cJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)