UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RCyuQRex94XT/C7Fu+rAt1gB+ONmmH2O8+5Vl2iEeLA=' 
WHERE 
  key_id = '06b8942107bcb13dc29c3cc0101db9b1940716f2d916e12cadf05c24cde5596b' 
  AND (
    token = 'RCyuQRex94XT/C7Fu+rAt1gB+ONmmH2O8+5Vl2iEeLA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00080