UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P74PDNl/Be7R8EMqzoN/6K6bCj1ArJgHx7mB3vG9Mgw='
WHERE
key_id = 'b6d2bde507170313552cf169f95b9a831eb5d866dc99f85c0abd4b996f62e28e'
AND (
token = 'P74PDNl/Be7R8EMqzoN/6K6bCj1ArJgHx7mB3vG9Mgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)