UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+1E6hACcMbiNpqvCJJNNWB1TzzH7ObWx3+pEySauJWY='
WHERE
key_id = '5a536f352953327de452a0c9484de6e7680950326d6671a3d4c2addab4d8e6b9'
AND (
token = '+1E6hACcMbiNpqvCJJNNWB1TzzH7ObWx3+pEySauJWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)