UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZfkRcs8WYkIfAUBVv2418s9srhegnbm6fJu4nJLkMM='
WHERE
key_id = 'b14c6a2c0a96794f6815ce6efe543860d97106a66ab198172f333b52ea500603'
AND (
token = 'pZfkRcs8WYkIfAUBVv2418s9srhegnbm6fJu4nJLkMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)