UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AkkBdkST3usBdglkAz4bMXlFoQg61w1/buE10Y4n4iM=' 
WHERE 
  key_id = 'b9cb30b0bcc026e241cab611beebf9fd44ea3987f92d28c58e6f9205015cd127' 
  AND (
    token = 'AkkBdkST3usBdglkAz4bMXlFoQg61w1/buE10Y4n4iM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042