UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZHBa0Xg3+BVgS7hkSkGTiSSCB3dLE1ihBoSYMs+hsg='
WHERE
key_id = 'c4debe06cce2db542766d82d2b4c74c2d59775e2008bdf0b07b76e62490be809'
AND (
token = 'nZHBa0Xg3+BVgS7hkSkGTiSSCB3dLE1ihBoSYMs+hsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)