UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FPkyhgi3Q2pWphGyNq//PF89CxT2u5Tb3KqWPgq9X7o=' 
WHERE 
  key_id = '2bc74eb869e5b2de6ee1d6ff9c9f091006e7877668c38e82815e2b13ea2ea696' 
  AND (
    token = 'FPkyhgi3Q2pWphGyNq//PF89CxT2u5Tb3KqWPgq9X7o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022