UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mmxHYpvfhL7kESwi3188BFxenmvhJ/tkVCbuas2t7yY=' 
WHERE 
  key_id = 'fd95c3c994cc8035ea95d998538c7ca35bf35b7dc37025ce05d577e79093b44b' 
  AND (
    token = 'mmxHYpvfhL7kESwi3188BFxenmvhJ/tkVCbuas2t7yY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024