UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'F20Wy82ukypmRLY1jFXeSxSDn6E8K3WT2gEFbNDN48I=' 
WHERE 
  key_id = '1fc58d36749e25cc3411131e6bfdca0138d9b10a868d57ebcd4562c2e5699a72' 
  AND (
    token = 'F20Wy82ukypmRLY1jFXeSxSDn6E8K3WT2gEFbNDN48I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040