UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bVDyq3MZlTl8HLL7CQd6LbjnGlWemZ3kv8h6PraqC2Y='
WHERE
key_id = '0d077722f5c12155b2bd9da4ee358daf78c74b7a72c4fda031e9c3fe2c607315'
AND (
token = 'bVDyq3MZlTl8HLL7CQd6LbjnGlWemZ3kv8h6PraqC2Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)